﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Sharp.Migrations;

namespace Budgeter.Migrations
{
    class _001_Create_Table_Interval : SchemaMigration
    {

        public override void Up()
        {
            Add.Table("Interval").WithColumns(
                Column.AutoIncrement("IntervalId").AsPrimaryKey(),
                Column.String("Name").NotNull(),
                Column.String("Abbreviation").NotNull(),
                Column.Single("YearEquivalent").NotNull()
            );
        }

        public override void Down()
        {
            Remove.Table("Interval");
        }
    }

}
